/*
 *代码由框架生成,任何更改都可能导致被代码生成器覆盖
 *如果数据库字段发生变化，请在代码生器重新生成此Model
 */
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using VOL.Entity.SystemModels;

namespace VOL.Entity.DomainModels
{
    [Entity(TableCnName = "大数据SAP交货单表",TableName = "big_data_delivery_note")]
    public partial class big_data_delivery_note:BaseEntity
    {
        /// <summary>
       ///SAP交货单表id
       /// </summary>
       [Key]
       [Display(Name ="SAP交货单表id")]
       [Column(TypeName="uniqueidentifier")]
       [Editable(true)]
       [Required(AllowEmptyStrings=false)]
       public Guid big_data_delivery_note_id { get; set; }

       /// <summary>
       ///SAP销售订单号
       /// </summary>
       [Display(Name ="SAP销售订单号")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string sap_order_no { get; set; }

       /// <summary>
       ///SAP销售开票凭证
       /// </summary>
       [Display(Name ="SAP销售开票凭证")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string sap_sales_voucher { get; set; }

       /// <summary>
       ///SAP销售交货单号
       /// </summary>
       [Display(Name ="SAP销售交货单号")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string sap_sales_delivery_order_no { get; set; }

       /// <summary>
       ///SAP经销商客户的编号
       /// </summary>
       [Display(Name ="SAP经销商客户的编号")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string sap_dealer_customer_no { get; set; }

       /// <summary>
       ///运达方经销商ERP号
       /// </summary>
       [Display(Name ="运达方经销商ERP号")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string dealer_code { get; set; }

       /// <summary>
       ///运达方经销商名称
       /// </summary>
       [Display(Name ="运达方经销商名称")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string dealer_name { get; set; }

       /// <summary>
       ///售达方经销商ERP号
       /// </summary>
       [Display(Name ="售达方经销商ERP号")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string sold_dealer_code { get; set; }

       /// <summary>
       ///售达方经销商名称
       /// </summary>
       [Display(Name ="售达方经销商名称")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string sold_dealer_name { get; set; }

       /// <summary>
       ///入库时间
       /// </summary>
       [Display(Name ="入库时间")]
       [Column(TypeName="datetime")]
       [Editable(true)]
       public DateTime? in_stock_date { get; set; }

       /// <summary>
       ///SAP序列号(VIN)
       /// </summary>
       [Display(Name ="SAP序列号(VIN)")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string vin { get; set; }

       /// <summary>
       ///DMS销售订单号
       /// </summary>
       [Display(Name ="DMS销售订单号")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string dms_order_no { get; set; }

       /// <summary>
       ///物料编码
       /// </summary>
       [Display(Name ="物料编码")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string MATNR { get; set; }

       /// <summary>
       ///生产订单号
       /// </summary>
       [Display(Name ="生产订单号")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string AUFNR { get; set; }

       /// <summary>
       ///推送状态，0:未推送，1:已推送
       /// </summary>
       [Display(Name ="推送状态，0:未推送，1:已推送")]
       [Column(TypeName="int")]
       [Editable(true)]
       [Required(AllowEmptyStrings=false)]
       public int status { get; set; }

       /// <summary>
       ///创建人
       /// </summary>
       [Display(Name ="创建人")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string Creator { get; set; }

       /// <summary>
       ///创建时间
       /// </summary>
       [Display(Name ="创建时间")]
       [Column(TypeName="datetime")]
       [Editable(true)]
       public DateTime? CreateDate { get; set; }

       /// <summary>
       ///修改人
       /// </summary>
       [Display(Name ="修改人")]
       [MaxLength(255)]
       [Column(TypeName="varchar(255)")]
       [Editable(true)]
       public string Modifier { get; set; }

       /// <summary>
       ///修改时间
       /// </summary>
       [Display(Name ="修改时间")]
       [Column(TypeName="datetime")]
       [Editable(true)]
       public DateTime? ModifyDate { get; set; }

       /// <summary>
       ///过账日期
       /// </summary>
       [Display(Name ="过账日期")]
       [Column(TypeName="datetime")]
       public DateTime? BUDAT { get; set; }

       /// <summary>
       ///数量
       /// </summary>
       [Display(Name ="数量")]
       [Column(TypeName="int")]
       public int? LFIMG { get; set; }

       /// <summary>
       ///工厂
       /// </summary>
       [Display(Name ="工厂")]
       [MaxLength(100)]
       [Column(TypeName="varchar(100)")]
       public string WERKS { get; set; }

       /// <summary>
       ///上装成本
       /// </summary>
       [Display(Name ="上装成本")]
       [DisplayFormat(DataFormatString="16,6")]
       [Column(TypeName="decimal")]
       public decimal? NETPR1 { get; set; }

       /// <summary>
       ///底盘采购成本
       /// </summary>
       [Display(Name ="底盘采购成本")]
       [DisplayFormat(DataFormatString = "16,6")]
       [Column(TypeName = "decimal")]
       public decimal NETPR { get; set; }

       /// <summary>
       ///实际成本
       /// </summary>
       [Display(Name ="实际成本")]
       [DisplayFormat(DataFormatString="16,6")]
       [Column(TypeName="decimal")]
       public decimal? STPRS { get; set; }

       /// <summary>
       ///税金
       /// </summary>
       [Display(Name ="税金")]
       [DisplayFormat(DataFormatString="16,6")]
       [Column(TypeName="decimal")]
       public decimal? DMBTR2 { get; set; }

       /// <summary>
       ///收入
       /// </summary>
       [Display(Name ="收入")]
       [DisplayFormat(DataFormatString="16,6")]
       [Column(TypeName="decimal")]
       public decimal? DMBTR { get; set; }

       
    }
}